INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price FROM xcart_products, xcart_pricing , xcart_products_categories LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%7inch Single%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid='25' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='25' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%7inch Single%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products.forsale='Y' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid
Ranging from classic movie soundttracks like Easy Rider and Sound Of Music to the esoteric tastes of Michael Nyman and Gabriel Yared. If it's psychotic movies you're after, check out Angelo Badalamenti's Blue Velvet opus. Classic British TV soundtracks fr ::
Soundtracks/Musicals/Stageplays
:: Music
:: Elvis Shakespeare
Opening Hours
Mon-Sat: 10.00-18.00
Sun: Closed for the winter (open again in May)
Ranging from classic movie soundttracks like Easy Rider and Sound Of Music to the esoteric tastes of Michael Nyman and Gabriel Yared. If it's psychotic movies you're after, check out Angelo Badalamenti's Blue Velvet opus. Classic British TV soundtracks from Dad's Army, Morecombe & Wise and Tony Hancock nestle next to French arthouse (Diva) and American 70s (Can't Stop The Music) and the cover of Liza Minnelli in Cabaret is worth buying for that alone. Also, for the 5 people in the world who own a Laserdisc, we have some!
Soundtracks/Musicals/Stageplays
There are no available products under this category.
Ranging from classic movie soundttracks like Easy Rider and Sound Of Music to the esoteric tastes of Michael Nyman and Gabriel Yared. If it's psychotic movies you're after, check out Angelo Badalamenti's Blue Velvet opus. Classic British TV soundtracks fr ::
Soundtracks/Musicals/Stageplays
:: Music
:: Elvis Shakespeare